if object_id (N'[dbo].[delete_person]', N'P') IS NOT NULL
    drop procedure [dbo].[delete_person];
go

/********************************************************
creator: Zoran Arsovski
created: 03.11.2007.
last modifier: unknown
last modified: unknown

description: Procedurata brise red vo tabela Person
test: delete_person '1203980450666'
*********************************************************/

create procedure [dbo].[delete_person] 
(
	-- Input Parametars
	@embg varchar(20)
) as
begin
	if exists (select 1 from person where embg = @embg)
		delete from person
		where embg = @embg
end
go		